CREATE EXTERNAL TABLE ai_dw.geo_info_day(
                                            `id` string COMMENT 'full_address对应MD5唯一编码,关联id',
                                            `full_address` string COMMENT '拉取geo的地址关键字',
                                            `geo_coordinate` string COMMENT '高德爬取的GEO经纬度',
                                            `geo_info` string COMMENT 'GEO数据其他属性，如省市区',
                                            `poi_coordinate` string COMMENT '高德爬取的POI经纬度',
                                            `poi_info` string COMMENT 'POI数据其他属性，如省市区',
                                            `sign_city_id` int COMMENT '签收城市id',
                                            `receiver_city_id` int COMMENT '收件城市id',
                                            `city_id` int COMMENT '签收城市id分区')
    COMMENT 'GEO地址信息模型训练表'
    PARTITIONED BY (
        `dt` string COMMENT '日期分区')
    ROW FORMAT SERDE
        'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'
    STORED AS INPUTFORMAT
        'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat'
        OUTPUTFORMAT
            'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat'
    LOCATION
        '/dw/hive/ai_dw.db/external/geo_info_day'